vaccinationcenter
Table Name: vaccinationcenter
The vaccinationcenter table holds information about vaccination centers, including details about their registration, location, and associated metadata.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| mappedId | int(11) | Primary Key | Unique identifier for the vaccination center, linked to a location ID. |
| centerType | varchar(30) | Type of the vaccination center (e.g., hospital, clinic). | |
| createdDate | datetime | Timestamp of when the record was created. | |
| dateRegistered | datetime | NOT NULL | Date when the vaccination center was registered. |
| description | varchar(255) | Additional information about the center. | |
| fullName | varchar(255) | Full name of the vaccination center. | |
| lastEditedDate | datetime | Timestamp of the last edit made to the record. | |
| name | varchar(255) | UNIQUE | Unique name of the vaccination center. |
| shortName | varchar(30) | Abbreviated name of the vaccination center. | |
| createdByUserId | int(11) | ID of the user who created the record. | |
| lastEditedByUserId | int(11) | ID of the user who last edited the record. | |
| programId | int(11) | ID of the associated program. | |
| voided | tinyint(4) | DEFAULT '0' | Indicates if the record is voided (0 = active, 1 = voided). |
| voidedDate | datetime | Timestamp of when the record was voided, if applicable. | |
| voidedReason | varchar(45) | Reason for voiding the record, if applicable. | |
| organizationId | int(11) | ID of the associated organization. | |
| isBirthingCenter | tinyint(1) | DEFAULT '0' | Indicates if the center is a birthing center (0 = no, 1 = yes). |
Indexes
- Primary Key:
- mappedId: Unique identifier for the vaccination center.
- Additional Indexes:
- name: Ensures the name of each vaccination center is unique.
- FK41866ADAC79271AF: Index for the mappedId column.
- vaccinationcenter_lastEditedByUserId_user_mappedId_FK: Index for the lastEditedByUserId column.
- vaccinationcenter_createdByUserId_user_mappedId_FK: Index for the createdByUserId column.
- program_programId_vaccinationcenter_programId_FK_idx: Index for the programId column.
- organization_vaccinationcenter_idx: Index for the organizationId column.
Foreign Key Relations
- FK41866ADAC79271AF
- Column: mappedId
- References: location(locationId)
- Description: Links the vaccination center to its location details.
- organization_vaccinationcenter
- Column: organizationId
- References: organization(organizationId)
- Description: Associates the vaccination center with an organization.
- vaccinationcenter_createdByUserId_user_mappedId_FK
- Column: createdByUserId
- References: user(mappedId)
- Description: Identifies the user who created the vaccination center record.
- vaccinationcenter_lastEditedByUserId_user_mappedId_FK
- Column: lastEditedByUserId
- References: user(mappedId)
- Description: Identifies the user who last edited the vaccination center record.
- vaccinationcenter_ibfk_1
- Column: programId
- References: program(programId)
- Description: Links the vaccination center to a specific program it is part of.
Usage Notes
- Purpose:
- To store and manage details of vaccination centers.
- Useful for administrative tasks, reporting, and linking to other healthcare data.
- Reference Usage:
- The programId column connects vaccination centers to specific healthcare programs.
- The organizationId column allows grouping centers under organizations.